Eventually, the syntax was good, but what was wrong is the DestinationServer
. Instead using TEST,1234
I had to use the full organization address: TEST.XXX.YYY,1234
What's works locally only with TEST,1234
, is not working the same when talking on remote.
What's annoying is that it didn't throw any error, only when I asked the Sys admin to login to the machine I was able to see the popup with the error.
Detailed explanation for that, can be found here (also question which was raised by me):
https://stackoverflow.com/a/67047195/14976099
SSIS deploy command doesn't work on remote
I have the below deploy command which is working from my CMD (with no popup screen):
ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:"Integration Services\bin\Development\Integration Services.ispac" /DestinationServer:"TEST,1234" /DestinationPath:"/SSISDB/TEST/DEVOPS"
but when I'm running it thought Jenkins on windows server slave:
bat "ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:\"Integration Services\\bin\\Development\\Integration Services.ispac\" /DestinationServer:\"TEST,1234\" /DestinationPath:\"/SSISDB/TEST/DEVOPS\""
I get this exception:
Unhandled Exception: System.InvalidOperationException: Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.NetEnterpriseServers.ExceptionMessageBox.Show(IWin32Window owner)
at Microsoft.SqlServer.IntegrationServices.Wizard.Common.WizardMessageBox.Show(Exception error)
at Microsoft.SqlServer.IntegrationServices.Deployment.Program.Main(String[] args)
From what I read, this is probably due to popup screen which happens on the remote, but from the other hand, both commands are exactly the same
-
arielman2304 676 Reputation points
May 18, 2021, 4:41 PM
1 additional answer
Sort by: Most helpful
-
MotoX80 35,626 Reputation points
May 15, 2021, 1:02 AM I don't have any way to test Jenkins, but based on experience (and depending on how Jenkins parses quotes) you may need to additional double quote characters in order to get a double quote character included in the command.
From the 1st to 2nd double quotes the command would be:
ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:\
Try these commands and see if either of them works. I'm thinking that the second one might work.
bat "ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:\""Integration Services\\bin\\Development\\Integration Services.ispac\"" /DestinationServer:\""TEST,1234\"" /DestinationPath:\""/SSISDB/TEST/DEVOPS\""" bat "ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:\"""Integration Services\\bin\\Development\\Integration Services.ispac\""" /DestinationServer:\"""TEST,1234\""" /DestinationPath:\"""/SSISDB/TEST/DEVOPS\""""